bst timezone to est

Network time Protocol (NTP) is also a new exam requirement for RHCE. Study time also by the way to review how to set up Linux time, now take out and share with youSetting up an NTP server is not difficult, but NTP itself is a very complex protocol.

Summary:GMT/UTC/CST;/etc/localtime,/usr/share/zoneinfo/* time zone file,/etc/profile plus TZ variable;Hardware time RTC, system time; date,hwclock,tzselect;NTP relay SERVER;RPM–IVH ntp-*;ntpdate 0.uk.pool.ntp.org; Ntpq–p,watch

remark: article reproduced from: http://www.cnblogs.com/liuyou/archive/2012/07/29/2614338.html Summary: GMT/UTC/CST; /etc/localtime,/usr/share/zoneinfo/* time zone file,/etc/profile plus TZ variable; Hardware time RTC, system time;

Linux ntp time server configuration tutorial, ntp server configuration Network Time Protocol (NTP) is also a new test requirement for RHCE. During study, I also reviewed how to set the Linux Time. Now I will share it with you. It is not difficult

Internal storage format: century, year, month, day, hour, minute, second The default format is: DD-MON-RR. Sysdate returns the current system time. SELECT sysdate from DUAL; The mathematical operation of a date SELECT (sysdate-hire_date)/7 from

Date functionDate functions manipulate Date values (fields of date type), timestamp values (TIMESTAMP, TIMESTAMP with time ZONE, and TIMESTAMP with the fields of the local time ZONE type), and interval values (INTERVAL day to SECOND and INTERVAL

Article Source: http://www.cnblogs.com/zfc2201/p/3284965.htmlDate formatting: Alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss dy 'Note: The HH24 format cannot be set to am pm on PM Indicatorsysdate"function": Returns the current date.

Numeric type functions:Absolute:ABS (x) "function" returns the absolute value of x "parameter" x, numeric Expression "return" number "example" Select ABS (+), ABS ( -100) from dual;--------------------------------------------------------------------

---------------------------------------------Date/Time function-------------------------------------------------1:   Sysdate is used to get the current date of the system select Sysdate from Dual;--2:  add_months Add or Subtract month select To_char